﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$UserLoginDBConnection$" type="$UserLoginDbType$" defaultFormatter="bizobj User">
  <SqlStatement hasResults="true">
    SELECT id,userName,password,firstName,lastName,companyId,companyId as activeCompanyId,email,enable,dateUpdated, dateCreated
      FROM Users
      WHERE userName=@userName AND password=@password
      AND CompanyId=@companyId
    
  </SqlStatement>
  <Param name="userName" type="UnicodeVarChar"/>
  <Param name="password" type="UnicodeVarChar"/>
  <Param name="companyId" type="UniqueIdentifier"/>
  
</DbDataRequest>